|
|
|
|
|
|
|
A Data Access Objects. DAO is the first object library/data access mechanism that provided an interface to the Microsoft Jet database engine to access native Jet databases as well as other kinds of data sources. |
|
|
|
|
|
|
|
|
Q What is a benefit of RDO in query processing? |
|
|
|
|
|
|
|
|
A RDOand its DAO Data control alternative, the Remote Data controllets your applications access ODBC data sources without using a local query processor. Without localizing a query processor, your applications enjoy faster performance and more flexibility when accessing remote database engines. |
|
|
|
|
|
|
|
|
The workshop includes quiz questions to help gauge your grasp of the material. You'll find the answers to this quiz in Appendix A, Answers. Even if you feel that you understand the concepts presented here, you should work through the quiz. The last section contains exercises to help reinforce your learning. |
|
|
|
|
|
|
|
|
1. What does UDA stand for? What is its purpose? |
|
|
|
|
|
|
|
|
2. What features does the Remote Data Services (RDS) component provide for ADO? |
|
|
|
|
|
|
|
|
3. What are three reasons ADO was created by Microsoft? |
|
|
|
|
|
|
|
|
4. True or False: RDO enables you to limit the number of rows returned or processed. |
|
|
|
|
|
|
|
|
5. What are the advantages and disadvantages of using the ODBC API? |
|
|
|
|
|
|
|
|
6. What are the general operations involved in working with the ODBC API? |
|
|
|
|
|
|
|
|
7. What are the advantages and disadvantages of using Data controls? |
|
|
|
|
|
|
|
|
1. Using the code on the CD-ROM, create and implement collection classes for the connection classes (DBAdoConnection, DBRdoConnection, and DBDaoConnection) and the resultset classes (DBAdoResultset, DBRdoResultset, and DBDaoResultset). |
|
|
|
|
|
|
|
|
2. Using the updateOneRecord method of DBAdoResultset (the code is on the CD-ROM), create a corresponding method to update a batch of records. (Hint: Think of ways you might update a group of records in a loop.) |
|
|
|
|
|